03. Video: Introduction to JOINs
Your First JOIN
This entire lesson will be focused on JOIN s. The whole purpose of JOIN statements is to allow us to pull data from more than one table at a time.
Again - JOIN s are useful for allowing us to pull data from multiple tables. This is both simple and powerful all at the same time.
With the addition of the JOIN statement to our toolkit, we will also be adding the ON statement.
We use
ON
clause to specify a
JOIN
condition which is a logical statement to combine the table in
FROM
and
JOIN
statements.